SUMROUND3D

Rounds all numbers in a specified range in all worksheets in a workbook to a specified number of digits, then adds them up to return a total. SUMROUND3D is very similar to the SUMROUND function of Edwin's Power Tools (EPT).

The main difference is that SUMROUND3D considers all worksheets, while the SUMROUND function doesn't.

Syntax

SUMROUND3D(range_input, decimal_places)

range_input - is the range for which you want to determine the total value or sum. The same range in all worksheet in the workbook will be considered.

decimal_places - specifies the number of digits to which you want to round numbers.

Remark

• Arguments that are error values or text that cannot be translated into numbers cause errors.
• If decimal_places is greater than 0 (zero), then numbers are rounded to the specified number of decimal places.
• If decimal_places is 0, then numbers are rounded to the nearest integer.
• If decimal_places is less than 0, then numbers are rounded to the left of the decimal point.

 

[ ©2000-2001, Edwin H. B. Tam, All rights reserved ]